AND(logical1,logical2,…) TRUE if every argument is TRUE, otherwise, FALSE
AREAS(reference) Number of areas in reference
AVERAGE(number1,number2,…) Average of numbers in numbers
CELL(type_of_info,reference) Information about formatting, location, or contents of upper-left cell in reference
CHOOSE(index_number,value1,value2,…) Use index_number to select a value from values
COLUMN(reference) Column numbers in reference
COLUMNS(array) Number of columns in array
COUNT(value1,value2,…) Count of numbers in values
DATE(year,month,day) Serial number of specified date
DATEVALUE(date_text) Serial number of date_text
DAVERAGE(database,field,criteria) Average of numbers in specified field of records in database matching criteria
DAY(serial_number) Converts serial_number to a day of the month
DCOUNT(database,field,criteria) Count of numbers in specified field of records in database matching criteria
DCOUNTA(database,field,criteria) Count of non-empty cells in specified field of records in database matching criteria
DDB(cost,salvage,life,period,factor) Depreciation of an asset using the double-declining balance method
DMAX(database,field,criteria) Maximum of numbers in specified field of records in database matching criteria
DMIN(database,field,criteria) Minimum of numbers in specified field of records in database matching criteria
DPRODUCT(database,field,criteria) Product of numbers in specified field of records in database matching criteria
DSTDEV(database,field,criteria) Standard Deviation of numbers in specified field of records in database matching criteria
DSTDEVP(database,field,criteria) Standard Deviation of a population, based on the entire population, using numbers in specified field of records in database matching criteria
DSUM(database,field,criteria) Sum of numbers in specified field of records in database matching criteria
DVAR(database,field,criteria) Estimate of variance of a population, based on a sample, using numbers in specified field of records in database matching criteria
DVARP(database,field,criteria) Variance of a population, based on the entire population, using numbers in specified field of records in database matching criteria
EXP(number) e(2.718…) to the power number
FACT(number) Factorial of number
FALSE() Logical value FALSE
FV(rate,nper,pmt,pv,type) Future value of investment
GROWTH(known_y’s,known_x’s,new_x’s) Values on exponential trend y=b*m^x
HLOOKUP(lookup_value,table_array,row_index_num) Value in a table selected by lookup_value
HOUR(serial_number) Converts serial_number to an hour of the day
IF(logical_test,value_if_true,value_if_false) Value_if_true if logical_test is TRUE; value_if_false if logical_test is FALSE
INDEX(array,row_num,column_num) Reference in ref or value in array selected by index values
INDEX(ref,row_num,column_num,area_num)
INDIRECT(ref_text,type_of_ref) Contents of the cell from its ref
INT(number) Number rounded down to the nearest integer
IPMT(rate,per,nper,pv,fv,type) Interest payment for an investment over a given period
IRR(values,guess) Internal rate of return of values
ISBLANK(value) TRUE if value is blank
ISERR(value) TRUE if value is any error value except #N/A
ISERROR(value) TRUE if value is any error value
ISLOGICAL(value) TRUE if value is a logical value
ISNA(value) TRUE if value is the error value #N/A
ISNONTEXT(value) TRUE if value is not text
ISNUMBER(value) TRUE if value is a number
ISREF(value) TRUE if value is reference
ISTEXT(value) TRUE if value is text
LINEST(known_y’s,known_x’s) Parameters of linear trend y=m*x+b
LN(number) Natural logarithm of number
LOG(number,base) Logarithm of number in base
LOG10(number) Base 10 logarithm of number
LOGEST(known_y’s,known_x’s) Parameters of exponential trend y=b*m^x
LOOKUP(lookup_value,array) Value in a table selected by lookup_value
LOOKUP(lookup_value,lookup_vector,result_vector)
MATCH(lookup_value,lookup_array,type_of_match) Index of a value selected by lookup_value
MAX(number1,number2,…) Maximum number in numbers
MDETERM(array) Determinant of array
MIN(number1,number2,…) Minimum number in numbers
MINUTE(serial_number) Converts serial_number to an hour of the day
MINVERSE(array) Inverse of matrix or array
MIRR(values,finance_rate,reinvest_rate) Modified internal rate of return of values
MMULT(array1,array2) Matrix product of array1 and array2
MOD(number,divisor_number) Remainder of number divided by divisor_number
MONTH(serial_number) Converts serial_number to a month of the year
N(value) Value translated into a number
NA( ) Error value #N/A
NOT(logical) TRUE if logical is FALSE;FALSE if logical is TRUE
NOW() Serial_number of current date and time
NPER(rate,pmt,pv,fv,type) Number of payments of investment
NPV(rate,value1,value2,…) Net present value of values
OR(logical1,logical2,…) TRUE if any argument is TRUE; otherwise, FALSE
PI() Value of π
PMT(rate,nper,pv,fv,type) Periodic payment of investment
PPMT(rate,per,nper,pv,fv,type) Payment on the principal for an investment over a given period
PRODUCT(number1,number2,…) Product of numbers in numbers
PV(rate,nper,pmt,fv,type) Present value of investment
RAND() Random number between 0 and 1
RATE(nper,pmt,pv,fv,type,guess) Rate returned on investment
ROUND(number,number_of_digits) Rounds number to number_of_digits
ROW(reference) Row numbers in reference
ROWS(array) Number of rows in array
SECOND(serial_number) Converts serial_number to a second
SIGN(number) Sign of number
SLN(cost,salvage,life) Straight-line depreciation for an asset
SQRT(number) Square root of number
STDEV(number1,number2,…) Estimate of standard deviation of a population based on a sample
STDEVP(number1,number2,…) Standard deviation of a population based on the entire population
SUM(number1,number2,…) Sum of numbers in numbers
SYD(cost,salvage,life,per) Sum-of-years’ digits depreciation for an asset
T(value) Value translated into text
TIME(hour,minute,second) Serial number of a specified time
TIMEVALUE(time_text) Serial number of a time_text
TRANSPOSE(array) Transpose of array
TREND(known_y’s,known_x’s,new_x’s) Values on linear trend
TRUE() Logical value TRUE
TRUN(number) Integer part of number
TYPE(value) Type of value
VAR(number1,number2,…) Estimate of variance of a population based on a sample
VARP(number1,number2,…) Variance of a population based on the entire population
VLOOKUP(lookup_value,table_array,col_index) Value in a table selected by lookup_value
WEEKDAY(serial_number) Converts serial_number to a day of the week
YEAR(serial_number) Converts serial-number to a year
CHAR(number) ANSI character corresponding to number
CLEAN(text) Removes non-printable characters from text
CODE(text) ASCII code of the first character in text
DOLLAR(number,decimals) Rounds number and gives as text in currency format
EXACT(text1,text2) Tests to see if text1 and text2 are exactly the same
FIND(find_text,within_text,start_at_num) Finds find_text within within_text
FIXED(number,decimals) Rounds number and gives as text
LEFT(text,number_of_characters) Extracts first number_of_characters from text
LEN(text) Length of text
LOWER(text) Converts text to lowercase
MID(text,start_number,number_of_characters) Extracts number_of_characters from text
PROPER(text) Converts text to initial capitals
REPLACE(old_text,start_num,num_chars,new_text) Replaces num_chars characters in old_text with new_text
REPT(text,number_times) Repeats text number_times times
RIGHT(text,number_of_chars) Last number_of_chars characters in text
SEARCH(find_text,within_text,start_at_num) Searches for find_text within within_text
SUBSTITUTE(text,old_text,new_text,instance_number) Substitutes new_text for old_text in text
TEXT(value,format_text) Converts value to text using format format_text
TRIM(text) Removes spaces from text
UPPER(text) Converts text to uppercase
VALUE(text) Converts text to a number
ACOS(number) Arccosine of number
ASIN(number) Arcsine of number
ATAN(number) Arctangent of number
ATAN2(x_number,y_number) Arctangent of point (x_number,y_number)
